-
Re: Unhide specific columns on a sheet
This + Grouping Columns is fundamental for the larger sheets, particularly those in finance / budgets which have commonalities across sections and also a lot of helper columns which typically are hid…9 · -
Re: Introducing the PeerConnect Program!
Excellent Idea, look forward to connecting with a likeminded enthusiast in the community!1 · -
Re: Auto Generate Defect ID
Add an auto number column called number Then have another column, called defect number, (text/number) with the formula =IF([Status]@row = "Defect", "Defect " + Number@row, "&…1 · -
Re: COUNTIFS a the number of instances a number appear in a column
=COUNTIF([No Activity]:[No Activity], "0") If this helped, please upvote - it helps me and other users find answers.1 · -
Re: What is the longest formula you've created?
=IF(AND(MONTH(TODAY()) = 1, [Jan Actual]@row = 0), [Jan Planned]@row, IF(AND(MONTH(TODAY()) = 2, [Feb Actual]@row = 0), [Feb Planned]@row, IF(AND(MONTH(TODAY()) = 3, [Mar Actual]@row = 0), [Mar Plann…2 ·